﻿CREATE TABLE [dbo].[SailMeasurement_Tbl] (
    [SailMeasurementID] INT            IDENTITY (1, 1) NOT NULL,
    [MeasurementID]     INT            NULL,
    [SailType]          NVARCHAR (50)  NULL,
    [Luff]              FLOAT          NULL,
    [Leech_Clew]        FLOAT          NULL,
    [Foot_Lp]           FLOAT          NULL,
    [UseFoot]           BIT            NOT NULL,
    [UseLeech]          BIT            NOT NULL,
    [TackHeight]        FLOAT          NULL,
    [CofE]              INT            NULL,
    [Stay]              NVARCHAR (50)  NULL,
    [SheetTrack2]       BIT            NOT NULL,
    [SheetError]        NVARCHAR (100) NULL,
    [LastUpdated]       NVARCHAR (50)  NULL,
    [OrderLineItemID]   INT            NULL,
    [OrderID]           INT            NULL,
    [OrderLineItem]     INT            NULL,
    [QuoteSailTypeID]   INT            NULL,
    [GenSailTypeID]     INT            NULL,
    [StayID]            INT            NULL,
    [QuoteID]           INT            NULL,
    [QuoteLineItemID]   INT            NULL,
    [QuoteLineItem]     INT            NULL
);

